import pandas as pd
#及时之前设置ID为索引，再次读取也会再次输出新的索引
#在read_excel()时就设置好索引，index_col为ID
df = pd.read_excel('C:/Users/LXL/Desktop/PandasVersusExcel/output1.xlsx', index_col="ID")
print(df.head())
df.to_excel('C:/Users/LXL/Desktop/PandasVersusExcel/output2.xlsx')
print('Done!')
